When a formatted, non-integer, numeric variable is used as a level within a SAS OLAP cube, the drill-through result might contain the wrong records.

As a workaround, you can store the formatted value as a character string in the data. To create a character column from a numeric variable and a format, you can use the PUT function as shown in the following example:

  data newdata;
    set olddate;
    newchar = PUT(oldnum, dollar10.2);
  run;

Operating System and Release Information